CREATE TABLE [dbo].[WorkflowServiceWorker]
(
[WorkflowServiceKey] [uniqueidentifier] NOT NULL,
[WorkItemQueueKey] [uniqueidentifier] NOT NULL,
[WorkflowInstanceKey] [uniqueidentifier] NOT NULL,
[CreatedOn] [datetime] NOT NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[WorkflowServiceWorker] ADD CONSTRAINT [PK_WorkflowServiceWorker] PRIMARY KEY CLUSTERED ([WorkflowServiceKey], [WorkItemQueueKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_WorkflowServiceWorker_WorkflowInstanceKey] ON [dbo].[WorkflowServiceWorker] ([WorkflowInstanceKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_WorkflowServiceWorker_WorkItemQueueKey] ON [dbo].[WorkflowServiceWorker] ([WorkItemQueueKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[WorkflowServiceWorker] ADD CONSTRAINT [FK_WorkflowServiceWorker_WorkflowInstance] FOREIGN KEY ([WorkflowInstanceKey]) REFERENCES [dbo].[WorkflowInstance] ([WorkflowInstanceKey])
GO
ALTER TABLE [dbo].[WorkflowServiceWorker] ADD CONSTRAINT [FK_WorkflowServiceWorker_WorkflowService] FOREIGN KEY ([WorkflowServiceKey]) REFERENCES [dbo].[WorkflowService] ([WorkflowServiceKey])
GO
ALTER TABLE [dbo].[WorkflowServiceWorker] ADD CONSTRAINT [FK_WorkflowServiceWorker_WorkItemQueue] FOREIGN KEY ([WorkItemQueueKey]) REFERENCES [dbo].[WorkItemQueue] ([WorkItemQueueKey])
GO